Copyright: Copyright © 1996-1997 PierSoft
Citation: Copyright © 1996-1997 PierSoft


TECHNICAL SUPPORT

Registered users can obtain technical support by contacting PierSoft via e-mail at

TechSupport@piersoft.demon.co.uk

If you have any suggestions for improvement of this application or wish to report any bugs please make an entry into the Bug Report form at http://www.piersoft.demon.co.uk.


LOOKUP MAINTENANCE FORM

This form enables you to add new items to the various lookup tables used throughout the application.

Click on the appropriate tab to view the table you want.

Note:

1/ Please think carefully before making new entries, as overlapping definitions can cause problems when trying to extract data at a later stage.

2/ It is possible to to delete entries in the lookup table, but this is not advisable. It may mean 'stranding' some records when they are being extracted for a report.


REGISTRATION

This product may be registered in the following ways:

Via PierSoft directly:

http://www.piersoft.demon.co.uk/register

Via Compuserve:

GO SWREG

Registration ID is 15926 for Lifetime 32

Registration ID is 15916 for Lifetime 16

Registering one LifeTime product gives you a licence to use it on both the 16 and 32-bit platforms.


About Glossary Help
This file contains generic help for use in PierSoft Help files.

(This topic is not available via any links.)


Change Index
Current Index

Click on the drop-down arrow or button to see the available indexes. The order of records in the master table will then be sorted accordingly. This is useful if you wish to see all Students together, for instance.


GLOSSARY

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

A

Accelerators

B

Browse

C

Column

Child Window

D

Data Model

Detail Table

Drop down edit boxes

E

F

Field

Filter

G

H

I

Index

J

K

Keyboard accelerators

Key field

Key violation

L

Lookup tables

M

Main Window

Master table

N

O

One-to-Many

One-to-One

P

Q

R

Record

S

T

Table

U

V

VCR Buttons

W

X

Y

Z


VCRButtons
VCR Navigation Buttons


Key field

A Key field is used, singly or with key fields to create a uniquely identifiable record. An attempt to enter a new record with matching values in the key field(s) will trigger a Key Violation.


Key Violation

This occurs when an attempt is made to post a record whose key fields clash with an existing record.


One-to-One

This signifies a relationship between two tables. Each  record in the master table can only have one record attached to it in the detail table.


One-to-Many

This signifies a relationship between two tables. Each single record in the master table may have many records attached to it in the detail table


Lookup table
Lookup tables

These are usually small tables that hold static information. They assist data entry by allowing the user to pick from the pre-defined set of values. They typically fill a Drop Down Edit Box.


Index

A device used to sort a table. Typically an index is on an individual field. When the index is applied the user's view of the table will change to the new sort order. this is particularly apparent when browsing records.


Drop down edit boxes

By clicking on the button to the right of a drop down edit box a list of values is opened up. A choice may then be made from this list to enter into the field. By typing a (case sensitive) letter the list will jump to the first occurence of that letter.


Filter

A device used to restrict the view that the user sees of a particular table.


Field

An item of information in a table. A collection of related fields make up one record.


Record

A horizontal row in a Paradox table that contains a group of related fields of data.


Table

A structure made up of records (rows) and fields (columns) that contain information.


Data Model

The relationship between the constituent tables of the database


Main Window

The main form of the Application. All the constituent forms for data entry, known as child windows, are contained within it.


Child Window

A resizable form within the application. See also Main Window


Column

Another name for a field in a table


Browse
Browse Records

Most forms have a Browse Records page. this option allows you to quickly scan through the records in the form master table.


Keyboard Accelerators

A Menu item or field label that has a letter underlined, thus 'File'.

If you press the ALT key, simultaneously with the underlined letter the focus will switch immediately to the menu item or associated field.


Accelerators

See Keyboard Accelerators


Setup Printer

This option allows you to choose a particular printer. Set this prior to running the report if you do not want to use the default printer specified in your Control Panel. It is particularly useful if you want to use the Generic Text printer to prepare an ascii file, for example.


Master
Master Table

This is the main table on a form. Navigating by the VCR buttons etc will move you through this table. See also detail table


Detail
Detail Table

Typically each form is made up of a Master table which has several detail tables linked to it.